﻿CREATE TABLE [dbo].[HotelsFacilities] (
    [HotelId]    INT NOT NULL,
    [FacilityId] INT NOT NULL,
    CONSTRAINT [PK_HotelsFacilities] PRIMARY KEY CLUSTERED ([HotelId] ASC, [FacilityId] ASC),
    CONSTRAINT [FK_HotelsFacilities_Facility] FOREIGN KEY ([FacilityId]) REFERENCES [dbo].[Facilities] ([FacilityId]),
    CONSTRAINT [FK_HotelsFacilities_Hotel] FOREIGN KEY ([HotelId]) REFERENCES [dbo].[Hotel] ([HotelId])
);

